Evaluates the DateTime value and returns the number of seconds that have passed between 00:00:00 (12:00 midnight) and the specified time.
The following examples are applicable to both Basic and Crystal syntax:
DateTimeToSeconds(#11/01/1998 11:30:15 AM#)
Instead of using DateTimeToSeconds (dt), you can use:
DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (dt)))
The above expression does not use UFLs and can be more efficient.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |